Adding Order Totals to an Invoice

Activation

The option Include all order lines on Invoices? has been added to the System Wide Setting - Options for Invoices.

Description:

Adds the following fields to an invoice to better explain where the invoice came from and what other invoices are associated with the order.

  • 1 - Status:
    • Partially Invoiced – Invoice tied to line, and shipped quantity ne 0, and Order quantity ne shipped quantity

    • Previously Invoiced – Invoice tied to line, and shipped quantity = order quantity.

    • Invoice Due – Line is in INPRINT (todays invoice. Being invoiced)

    • Not yet Invoiced – no Invoice tied to the line and not in INPRINT (todays invoice. Being invoiced)

    • Line Killed – Invoice tied to the line and shipped quantity = 0.

  • 2 - Lines:
    • Include all lines on the invoice that are associated with the order regardless if they are being invoiced or not.

    • If a line has been partially invoiced then this line will be shown multiple times. One time with a status of previously invoiced and the quantity that has been previously invoiced and another time with a status of Not yet invoiced or Invoice Due with the quantity being invoiced or still to be invoiced.

  • 3 - Order Details:
    • ORDER TOTAL W/TAX - This is the total of the entire order with tax.

    • PREVIOUSLY INVOICED W/TAX – This is the total of the lines from the order with tax that have already been invoiced.

  • 4 - Invoice Details:
    • CURRENT INVOICE AMOUNT – This is the total currently being invoiced minus tax

    • CURRENT NC SALES TAX – This is the total tax on current invoice

    • CURRENT INVOICE TOTAL – This is the invoice total on current invoice w/tax.

Current Invoice without New Fields